CREATE DATABASE diarydb;

USE diarydb;

CREATE TABLE entries (
    id INT AUTO_INCREMENT PRIMARY KEY,
    date DATE NOT NULL,
    weather VARCHAR(255) NOT NULL,
    mood VARCHAR(255) NOT NULL,
    events TEXT NOT NULL
);